NTISthis.com

Evidence Guide: ICTPRG402 - Apply query language

Student: __________________________________________________

Signature: _________________________________________________

Tips for gathering evidence to demonstrate your skills

The important thing to remember when gathering evidence is that the more evidence the better - that is, the more evidence you gather to demonstrate your skills, the more confident an assessor can be that you have learned the skills not just at one point in time, but are continuing to apply and develop those skills (as opposed to just learning for the test!). Furthermore, one piece of evidence that you collect will not usualy demonstrate all the required criteria for a unit of competency, whereas multiple overlapping pieces of evidence will usually do the trick!

From the Wiki University

 

ICTPRG402 - Apply query language

What evidence can you provide to prove your understanding of each of the following citeria?

Determine the requirements of developing queries

  1. Recognise various query-related terminologies
  2. Identify the type of data source for a chosen query language
  3. Identify and use the necessary tools, and environment, in building queries
Recognise various query-related terminologies

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Identify the type of data source for a chosen query language

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Identify and use the necessary tools, and environment, in building queries

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Write queries to retrieve and sort values

  1. Use an expression to retrieve values from a single unit
  2. Use an expression to combine values from more than one unit
  3. Use an expression to sort values into a certain order
Use an expression to retrieve values from a single unit

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Use an expression to combine values from more than one unit

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Use an expression to sort values into a certain order

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Write queries to selectively retrieve values

  1. Use an expression to filter a sequence, based on a predicate or a condition
  2. Use an expression to filter the subset of a sequence, based on a predicate or a condition
  3. Use an expression to extract a specific value by position
Use an expression to filter a sequence, based on a predicate or a condition

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Use an expression to filter the subset of a sequence, based on a predicate or a condition

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Use an expression to extract a specific value by position

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Perform a calculation in queries

  1. Use an expression to perform a calculation on numeric values
  2. Use an expression to perform an operation on text values
  3. Use an expression to perform an operation on date and time values
Use an expression to perform a calculation on numeric values

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Use an expression to perform an operation on text values

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Use an expression to perform an operation on date and time values

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assessed

Teacher: ___________________________________ Date: _________

Signature: ________________________________________________

Comments:

 

 

 

 

 

 

 

 

Instructions to Assessors

Evidence Guide

ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Determine the requirements of developing queries

1.1 Recognise various query-related terminologies

1.2 Identify the type of data source for a chosen query language

1.3 Identify and use the necessary tools, and environment, in building queries

2. Write queries to retrieve and sort values

2.1 Use an expression to retrieve values from a single unit

2.2 Use an expression to combine values from more than one unit

2.3 Use an expression to sort values into a certain order

3. Write queries to selectively retrieve values

3.1 Use an expression to filter a sequence, based on a predicate or a condition

3.2 Use an expression to filter the subset of a sequence, based on a predicate or a condition

3.3 Use an expression to extract a specific value by position

4. Perform a calculation in queries

4.1 Use an expression to perform a calculation on numeric values

4.2 Use an expression to perform an operation on text values

4.3 Use an expression to perform an operation on date and time values

Required Skills and Knowledge

ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Determine the requirements of developing queries

1.1 Recognise various query-related terminologies

1.2 Identify the type of data source for a chosen query language

1.3 Identify and use the necessary tools, and environment, in building queries

2. Write queries to retrieve and sort values

2.1 Use an expression to retrieve values from a single unit

2.2 Use an expression to combine values from more than one unit

2.3 Use an expression to sort values into a certain order

3. Write queries to selectively retrieve values

3.1 Use an expression to filter a sequence, based on a predicate or a condition

3.2 Use an expression to filter the subset of a sequence, based on a predicate or a condition

3.3 Use an expression to extract a specific value by position

4. Perform a calculation in queries

4.1 Use an expression to perform a calculation on numeric values

4.2 Use an expression to perform an operation on text values

4.3 Use an expression to perform an operation on date and time values

Evidence of the ability to:

select and use tools in developing, storing, and executing queries to extract the appropriate data required for ad hoc reports, or to support developers

incorporate calculations using control statements, operators and functions.

Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.

To complete the unit requirements safely and effectively, the individual must:

outline the information gathering methods

outline the data analysis techniques

define data mining

outline the characteristics of the data source

explain the features of the information system

explain typical systems and procedures.